﻿ /*
 *  ChgDoc CMS - GNU General Public License, version 3 (GPL-3.0)
 *  Copyright (C)  2012. Ian Quigley
 *  
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *  
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
*/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using SqliteORM;

namespace ChgDoc.Entity
{
    [Table]
    public class Authentication : TableBase<Authentication>
    {
        [PrimaryKey(true)]
        public long Id { get; set; }

        [Field]
        public string Mechanism { get; set; }

        [Field]
        public string MechanismsUniqueId { get; set; }

        [Field]
        public long AccountId { get; set; }

        [Field]
        public string IpAddress { get; set; }

        [Field]
        public DateTime LastLogin { get; set; }


        public static List<Authentication> ForAccount(long accountId)
        {
            return Get(ad => ad.Select().Where( Where.Equal("AccountId", accountId) ).ToList());
        }

        internal static Authentication ForMechanism(string mechanism, string uniqueId)
        {
            var auth = Get(ad => ad.Select().Where(
                    Where.And(Where.Equal("Mechanism", mechanism), Where.Equal("MechanismsUniqueId", uniqueId))))
                    .FirstOrDefault();

            if (auth != null)
                return auth;

            return new Authentication()
                {
                    Mechanism = mechanism,
                    MechanismsUniqueId = uniqueId
                };
        }

        internal static void DeleteForAccount( long id )
        {
            Do( ad => ad.Delete( Where.Equal( "AccountId", id ) ) );
        }
    }
}
